Aller au contenu principal

2.10.3-database-mgt

2.10.3 Database Mgt​

Database management primarily involves configuration of data sources from different types of databases, with the system featuring a built-in local database.

2.10.3.1 Database List​

Introduction to the database listing page:

  • Search: Search database names.
  • Operation: Provides a [Create] option, which opens a database configuration dialog for external data source setup.
  • Database fields: Database name, type, description, creator, create time
  • Database operations: a) Edit: Click the edit icon to access the corresponding external data source editing page. b) Delete: Click the delete icon to remove the data source.

2.10.3.2 Data Source Configuration​

Click "Create" to slide out the new window from the right side of the desktop.

  • Database title: Required, maximum of 50 Chinese characters.
  • Database type: Required, dropdown, supports four types: Oracle, MySQL, SQL Server, PostgreSQL. After selecting the type, the corresponding JDBC driver and connection URL are automatically populated.
  • JDBC driver: Required, automatically populated based on the database type.
  • URL link: Required. Automatically filled based on the database type, then modify the corresponding IP, port number, and database name in the link according to actual use.
  • Oracle data source supports configuration of the user (SCHEMA) parameter.
  • Username: Required, the username for the connected system database.
  • Password: Required. This is the database password for the connected system. Supports switching to plaintext input mode, with encrypted input as the default setting.
  • Users: Optional. If left it blank, it is available to everyone.
  • Description: Optional, multi-line input field.
  • Submit: When clicking submit, the system checks whether all fields on the page have been entered. If all fields are completed, the dialog box closes and displays an "Operation Successful" prompt. The list is automatically refreshed simultaneously.
  • Test: Click this action to automatically verify the connection to the database. If connected, it returns a "Test Successful" prompt; if unable to connect, it returns a "Test Failed" prompt.
  • Cancel: Close the dialog directly.